package com.website.travle.mapper;

import com.website.travle.pojo.User;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

/**
 * @author
 * @description 用户表
 * @date 2023-05-21
 */
public interface IUserDAO {
    int login(String username, String password) throws SQLException;

    int add(User user) throws SQLException;

    int update(User user) throws SQLException;

    int delete(int id) throws SQLException;

    //    分页条件查询
    List<User> pageByLikeName(Integer page, Integer limit, String name) throws SQLException;

    //    获取记录数
    int getTotal() throws SQLException;

}